/*
 Navicat Premium Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : localhost:3306
 Source Schema         : db_auth

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 27/10/2020 13:33:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_auth
-- ----------------------------
DROP TABLE IF EXISTS `tb_auth`;
CREATE TABLE `tb_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `sys_id` int(11) NOT NULL COMMENT '系统id',
  `name` varchar(30) NOT NULL COMMENT '权限名称',
  `status` tinyint(1) NOT NULL COMMENT '权限状态:0-不可用，1-可用，2-删除',
  `type` tinyint(1) NOT NULL COMMENT '权限类型:1-菜单，2-按钮，3-权限',
  `url` varchar(60) DEFAULT NULL COMMENT '权限url',
  `auth_key` varchar(30) NOT NULL COMMENT '权限标识',
  `sort_no` int(5) NOT NULL COMMENT '排列序号',
  `parent_id` int(11) unsigned DEFAULT '0' COMMENT '父权限id',
  `clazz` varchar(30) DEFAULT NULL COMMENT '权限样式',
  `target` varchar(100) DEFAULT NULL COMMENT '跳转目标页面名称',
  `description` varchar(200) DEFAULT NULL COMMENT '描述信息',
  `create_user_id` int(11) DEFAULT NULL COMMENT '创建信息的用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_user_id` int(11) DEFAULT NULL COMMENT '更新用户',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='权限信息表';

-- ----------------------------
-- Records of tb_auth
-- ----------------------------
BEGIN;
INSERT INTO `tb_auth` VALUES (21, 1, '测试01', 1, 1, '/auth', 'auth', 1, 0, NULL, NULL, NULL, 1, '2020-06-20 11:01:02', NULL, NULL);
INSERT INTO `tb_auth` VALUES (22, 1, '测试02', 1, 1, '/auth/insert', 'auth/insert', 2, 0, NULL, NULL, NULL, 1, '2020-06-20 11:02:46', NULL, NULL);
INSERT INTO `tb_auth` VALUES (23, 1, '测试03', 1, 1, '/auth/addauth', 'addauth', 4, 0, NULL, NULL, NULL, 1, '2020-06-20 11:03:58', NULL, NULL);
INSERT INTO `tb_auth` VALUES (24, 1, '测试04', 1, 2, '123', '123', 123, 0, NULL, NULL, NULL, 1, '2020-06-20 12:25:50', NULL, NULL);
INSERT INTO `tb_auth` VALUES (25, 1, '测试05', 1, 3, '123', '123', 123, 0, NULL, NULL, NULL, 1, '2020-06-20 12:26:20', NULL, NULL);
INSERT INTO `tb_auth` VALUES (26, 1, '测试06', 1, 1, '123', '123', 123, 24, NULL, NULL, NULL, 1, '2020-06-20 12:45:25', NULL, NULL);
INSERT INTO `tb_auth` VALUES (27, 1, '测试07', 1, 1, '123', '123', 123, 26, NULL, NULL, NULL, 1, '2020-06-20 12:54:23', NULL, NULL);
INSERT INTO `tb_auth` VALUES (28, 1, '测试08', 1, 1, '123', '123', 123, 27, NULL, NULL, NULL, 1, '2020-06-20 12:55:29', NULL, NULL);
INSERT INTO `tb_auth` VALUES (29, 1, '测试08', 1, 1, '123', '123', 123, 28, NULL, NULL, NULL, 1, '2020-06-20 12:55:39', NULL, NULL);
INSERT INTO `tb_auth` VALUES (30, 1, '123', 2, 1, '', '123', 1234, 0, '', '', '', 25, '2020-10-22 02:26:00', 25, '2020-10-22 04:06:54');
INSERT INTO `tb_auth` VALUES (31, 1, '142', 2, 1, 'asdfasdf', '1234', 1234, 27, 'asdfasdf', '', 'asdfasdf', 25, '2020-10-22 02:37:09', 25, '2020-10-22 04:06:28');
COMMIT;

-- ----------------------------
-- Table structure for tb_dict
-- ----------------------------
DROP TABLE IF EXISTS `tb_dict`;
CREATE TABLE `tb_dict` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dict_key` varchar(30) NOT NULL COMMENT '字典键',
  `dict_value` varchar(120) NOT NULL COMMENT '字典值',
  `sort_no` int(5) NOT NULL COMMENT '字典排列序号',
  `dict_type_id` int(11) DEFAULT NULL COMMENT '字典类型id',
  `description` varchar(200) DEFAULT NULL COMMENT '描述信息',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '字典状态：0-可用，1-不可用，2-删除',
  `create_user_id` int(11) DEFAULT NULL COMMENT '创建信息的用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建的时间',
  `update_user_id` int(11) DEFAULT NULL COMMENT '更新信息的用户id',
  `update_time` datetime DEFAULT NULL COMMENT '更新的时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='数据字典信息表';

-- ----------------------------
-- Records of tb_dict
-- ----------------------------
BEGIN;
INSERT INTO `tb_dict` VALUES (1, 'skip', '.*/login/login', 1, 1, '登陆接口', 0, 1, '2020-06-15 14:43:21', NULL, NULL);
INSERT INTO `tb_dict` VALUES (2, 'skip', '.*/loginOut', 2, 1, '登出接口', 0, 1, '2020-06-15 14:45:24', NULL, NULL);
INSERT INTO `tb_dict` VALUES (3, 'skip', '.*/login/createImg', 3, 1, '验证码接口', 0, 1, '2020-06-15 17:21:19', NULL, NULL);
INSERT INTO `tb_dict` VALUES (4, 'skip', '.*/file/upload', 4, 1, '图片上传', 0, 1, '2020-08-06 10:24:17', NULL, NULL);
INSERT INTO `tb_dict` VALUES (5, '1', '无优惠', 1, 2, '无优惠', 0, 1, '2020-08-17 17:42:40', NULL, NULL);
INSERT INTO `tb_dict` VALUES (6, '2', '特惠促销', 2, 2, '特惠促销', 0, 1, '2020-08-17 17:43:08', NULL, NULL);
INSERT INTO `tb_dict` VALUES (7, '3', '会员价格', 3, 2, '会员价格', 0, 1, '2020-08-17 17:44:26', NULL, NULL);
INSERT INTO `tb_dict` VALUES (8, '4', '阶梯价格', 4, 2, '阶梯价格', 0, 1, '2020-08-17 17:44:47', NULL, NULL);
INSERT INTO `tb_dict` VALUES (9, '5', '满减价格', 5, 2, '满减价格', 0, 1, '2020-08-17 17:45:09', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `tb_dict_type`;
CREATE TABLE `tb_dict_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(20) NOT NULL COMMENT '类型编码',
  `name` varchar(20) NOT NULL COMMENT '类型名称',
  `description` varchar(200) DEFAULT NULL COMMENT '描述信息',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '字典类型状态：0-可用，1-不可用，2-删除',
  `create_user_id` int(11) DEFAULT NULL COMMENT '创建信息的用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建的时间',
  `update_user_id` int(11) DEFAULT NULL COMMENT '更新信息的用户id',
  `update_time` datetime DEFAULT NULL COMMENT '更新的时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_code` (`code`),
  UNIQUE KEY `uk_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='数据字典类型信息表';

-- ----------------------------
-- Records of tb_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `tb_dict_type` VALUES (1, 'skip', '登陆跳过所有验证接口', '登陆使用', 0, 1, '2020-06-15 14:41:35', NULL, NULL);
INSERT INTO `tb_dict_type` VALUES (2, 'discount', '优惠', '无优惠', 0, 1, '2020-08-17 17:41:28', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_login_log
-- ----------------------------
DROP TABLE IF EXISTS `tb_login_log`;
CREATE TABLE `tb_login_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(11) NOT NULL COMMENT '用户主键id',
  `user_name` varchar(255) DEFAULT NULL COMMENT '用户名',
  `sys_id` int(11) DEFAULT NULL COMMENT '系统主键id',
  `ip` varchar(15) DEFAULT NULL COMMENT '登录地址',
  `platform` tinyint(1) DEFAULT NULL COMMENT '登录平台:1-PC,2-Android,3-iPhone,4-微信',
  `time` datetime DEFAULT NULL COMMENT '登录时间',
  `description` varchar(200) DEFAULT NULL COMMENT '描述信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=557 DEFAULT CHARSET=utf8 COMMENT='用户登录日志表';

-- ----------------------------
-- Records of tb_login_log
-- ----------------------------
BEGIN;
INSERT INTO `tb_login_log` VALUES (535, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-16 02:35:42', NULL);
INSERT INTO `tb_login_log` VALUES (536, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-16 02:37:22', NULL);
INSERT INTO `tb_login_log` VALUES (537, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-16 02:55:05', NULL);
INSERT INTO `tb_login_log` VALUES (538, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-16 02:55:27', NULL);
INSERT INTO `tb_login_log` VALUES (539, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-16 02:56:38', NULL);
INSERT INTO `tb_login_log` VALUES (540, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-16 02:57:01', NULL);
INSERT INTO `tb_login_log` VALUES (541, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-16 03:06:38', NULL);
INSERT INTO `tb_login_log` VALUES (542, 27, '超级管理员02', 1, '127.0.0.1', 1, '2020-10-16 03:21:48', NULL);
INSERT INTO `tb_login_log` VALUES (543, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-18 01:07:20', NULL);
INSERT INTO `tb_login_log` VALUES (544, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-18 20:28:44', NULL);
INSERT INTO `tb_login_log` VALUES (545, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-18 21:24:59', NULL);
INSERT INTO `tb_login_log` VALUES (546, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-18 21:25:41', NULL);
INSERT INTO `tb_login_log` VALUES (547, 25, '超级管理员', 1, '0:0:0:0:0:0:0:1', 1, '2020-10-20 20:49:40', NULL);
INSERT INTO `tb_login_log` VALUES (548, 25, '超级管理员', 1, '0:0:0:0:0:0:0:1', 1, '2020-10-20 20:55:59', NULL);
INSERT INTO `tb_login_log` VALUES (549, 25, '超级管理员', 1, '10.108.14.59', 1, '2020-10-20 21:10:28', NULL);
INSERT INTO `tb_login_log` VALUES (550, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-21 00:50:07', NULL);
INSERT INTO `tb_login_log` VALUES (551, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-23 02:46:39', NULL);
INSERT INTO `tb_login_log` VALUES (552, 25, '超级管理员', 1, '10.108.14.45', 1, '2020-10-23 02:53:25', NULL);
INSERT INTO `tb_login_log` VALUES (553, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-23 03:06:55', NULL);
INSERT INTO `tb_login_log` VALUES (554, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-23 03:07:47', NULL);
INSERT INTO `tb_login_log` VALUES (555, 25, '超级管理员', 1, '127.0.0.1', 1, '2020-10-23 03:08:19', NULL);
INSERT INTO `tb_login_log` VALUES (556, 25, '超级管理员', 1, '10.108.14.67', 1, '2020-10-25 21:03:21', NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `tb_oper_log`;
CREATE TABLE `tb_oper_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(11) NOT NULL COMMENT '用户主键id',
  `type` varchar(10) DEFAULT NULL COMMENT '操作类型',
  `time` datetime NOT NULL COMMENT '操作时间',
  `description` varchar(200) DEFAULT NULL COMMENT '描述信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户操作日志表';

-- ----------------------------
-- Table structure for tb_org
-- ----------------------------
DROP TABLE IF EXISTS `tb_org`;
CREATE TABLE `tb_org` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL COMMENT '组织编码',
  `name` varchar(60) NOT NULL COMMENT '组织名称',
  `org_type` tinyint(1) DEFAULT '0' COMMENT '组织类别',
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '上级组织id',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态：0-不可用，1-可用，2-删除',
  `is_parent` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否是父节点 0 否 1 是',
  `description` varchar(200) DEFAULT NULL COMMENT '描述信息',
  `create_time` datetime DEFAULT NULL COMMENT '创建的时间',
  `create_user_id` int(11) DEFAULT NULL COMMENT '创建信息的用户id',
  `update_user_id` int(11) DEFAULT NULL COMMENT '更新信息的用户id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_code` (`code`),
  KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='组织消息表\r\n放弃部门表，统一为组织';

-- ----------------------------
-- Table structure for tb_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_role`;
CREATE TABLE `tb_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(90) DEFAULT NULL COMMENT '角色名',
  `org_id` int(11) DEFAULT NULL COMMENT '所属组织',
  `dict_value` int(2) DEFAULT NULL COMMENT '字典类型',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态：0-不可用，1-可用，2-删除',
  `description` varchar(600) DEFAULT NULL COMMENT '描述',
  `create_user_id` int(11) DEFAULT NULL COMMENT '创建人ID',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_user_id` int(11) DEFAULT NULL COMMENT '更新人ID',
  `update_time` datetime DEFAULT NULL COMMENT '系统时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='角色信息';

-- ----------------------------
-- Records of tb_role
-- ----------------------------
BEGIN;
INSERT INTO `tb_role` VALUES (4, '超级管理员', NULL, NULL, 1, NULL, 1, '2020-07-15 14:44:42', NULL, NULL);
INSERT INTO `tb_role` VALUES (5, '超级管理员1', NULL, NULL, 1, '', 1, '2020-07-15 14:45:33', NULL, NULL);
INSERT INTO `tb_role` VALUES (6, '超级管理员2', NULL, NULL, 1, '超级管理员2', 1, '2020-07-15 14:45:39', NULL, NULL);
INSERT INTO `tb_role` VALUES (7, '超级管理员3', NULL, NULL, 1, '超级管理员3', 1, '2020-07-15 14:52:31', NULL, NULL);
INSERT INTO `tb_role` VALUES (9, '123', NULL, NULL, 2, '删除', 25, '2020-10-22 01:09:52', 25, '2020-10-22 01:38:39');
INSERT INTO `tb_role` VALUES (10, '123', NULL, NULL, 2, NULL, 25, '2020-10-22 01:10:55', NULL, NULL);
INSERT INTO `tb_role` VALUES (11, '1234123', NULL, NULL, 2, NULL, 25, '2020-10-22 01:41:09', NULL, NULL);
INSERT INTO `tb_role` VALUES (12, '1234123', NULL, NULL, 2, NULL, 25, '2020-10-22 01:41:11', NULL, NULL);
INSERT INTO `tb_role` VALUES (13, '1234123', NULL, NULL, 2, NULL, 25, '2020-10-22 01:41:14', NULL, NULL);
INSERT INTO `tb_role` VALUES (14, '1234123', NULL, NULL, 2, NULL, 25, '2020-10-22 01:41:16', NULL, NULL);
INSERT INTO `tb_role` VALUES (15, '1234123', NULL, NULL, 2, NULL, 25, '2020-10-22 01:41:18', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_role_auth
-- ----------------------------
DROP TABLE IF EXISTS `tb_role_auth`;
CREATE TABLE `tb_role_auth` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `auth_id` int(11) NOT NULL COMMENT '权限id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_role_id_auth_id` (`role_id`,`auth_id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='角色权限信息表';

-- ----------------------------
-- Records of tb_role_auth
-- ----------------------------
BEGIN;
INSERT INTO `tb_role_auth` VALUES (57, 5, 22);
INSERT INTO `tb_role_auth` VALUES (58, 5, 23);
INSERT INTO `tb_role_auth` VALUES (56, 6, 25);
INSERT INTO `tb_role_auth` VALUES (52, 6, 26);
INSERT INTO `tb_role_auth` VALUES (53, 6, 27);
INSERT INTO `tb_role_auth` VALUES (54, 6, 28);
INSERT INTO `tb_role_auth` VALUES (55, 6, 29);
INSERT INTO `tb_role_auth` VALUES (46, 7, 28);
INSERT INTO `tb_role_auth` VALUES (47, 7, 29);
COMMIT;

-- ----------------------------
-- Table structure for tb_sys
-- ----------------------------
DROP TABLE IF EXISTS `tb_sys`;
CREATE TABLE `tb_sys` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(30) NOT NULL COMMENT '系统名称',
  `code` varchar(10) DEFAULT NULL COMMENT '系统代号',
  `description` varchar(200) DEFAULT NULL COMMENT '描述信息',
  `create_user_id` int(11) DEFAULT NULL COMMENT '创建信息的用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建的时间',
  `update_user_id` int(11) DEFAULT NULL COMMENT '更新信息的用户',
  `update_time` datetime DEFAULT NULL COMMENT '更新的时间',
  `status` tinyint(1) DEFAULT NULL COMMENT '状态：0-不可用，1-可用，2-删除',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统信息表';

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户真实姓名',
  `account` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '账号',
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '手机号',
  `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `status` tinyint(1) NOT NULL COMMENT '状态：0-不可用，1-可用，2-删除',
  `org_id` int(11) DEFAULT NULL COMMENT '组织id',
  `org_type` tinyint(1) DEFAULT '0' COMMENT '组织类别',
  `description` varchar(200) DEFAULT NULL COMMENT '描述信息',
  `create_user_id` int(11) DEFAULT NULL COMMENT '创建信息的用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建的时间',
  `update_user_id` int(11) DEFAULT NULL COMMENT '更新信息的用户id',
  `update_time` datetime DEFAULT NULL COMMENT '更新的时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='用户账号信息';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES (25, '超级管理员', 'admin', '17789895656', 'd39346b11421ee42c73bfea4c9083f4b', 1, NULL, 0, NULL, 1, '2020-07-17 16:30:48', NULL, NULL);
INSERT INTO `tb_user` VALUES (26, '超级管理员01', 'admin01', '17789895657', 'd39346b11421ee42c73bfea4c9083f4b', 0, NULL, 0, NULL, 1, '2020-07-17 16:33:03', NULL, '2020-07-17 16:58:47');
INSERT INTO `tb_user` VALUES (27, '超级管理员02', 'admin02', '17789895658', 'd39346b11421ee42c73bfea4c9083f4b', 1, NULL, 0, NULL, 1, '2020-07-17 16:36:27', NULL, '2020-07-20 11:06:35');
INSERT INTO `tb_user` VALUES (29, '测试', '12356', '13454565766', '', 2, NULL, 0, '', NULL, '2020-10-21 03:17:10', 25, '2020-10-21 04:03:05');
INSERT INTO `tb_user` VALUES (30, '测试01', '1234', '13894854333', 'd39346b11421ee42c73bfea4c9083f4b', 2, NULL, 0, NULL, NULL, '2020-10-21 03:17:58', NULL, NULL);
INSERT INTO `tb_user` VALUES (31, '测试02', '123', '13964645688', 'd39346b11421ee42c73bfea4c9083f4b', 2, NULL, 0, NULL, NULL, '2020-10-21 03:19:26', NULL, NULL);
INSERT INTO `tb_user` VALUES (32, '测试02', '12345', '13964645686', '', 2, NULL, 0, '', NULL, '2020-10-21 03:35:31', 25, '2020-10-21 04:02:55');
INSERT INTO `tb_user` VALUES (33, '测试02', '123456', '13964645687', '', 2, NULL, 0, '', NULL, '2020-10-21 03:36:23', 25, '2020-10-21 04:02:50');
INSERT INTO `tb_user` VALUES (34, '测试', '123', '13454645645', 'd39346b11421ee42c73bfea4c9083f4b', 2, NULL, 0, NULL, 25, '2020-10-21 22:02:03', NULL, NULL);
INSERT INTO `tb_user` VALUES (35, '测试', '1233', '13454645645', 'd39346b11421ee42c73bfea4c9083f4b', 2, NULL, 0, NULL, 25, '2020-10-21 22:02:40', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_user_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_user_role`;
CREATE TABLE `tb_user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(11) NOT NULL COMMENT '员工主键id',
  `role_id` int(11) NOT NULL COMMENT '角色主键id',
  `create_user_id` int(11) DEFAULT NULL COMMENT '分配人id',
  `create_time` datetime DEFAULT NULL COMMENT '分配时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_user_id_role_id` (`user_id`,`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COMMENT='用户角色信息表';

-- ----------------------------
-- Records of tb_user_role
-- ----------------------------
BEGIN;
INSERT INTO `tb_user_role` VALUES (27, 25, 4, 1, '2020-07-17 16:30:48');
INSERT INTO `tb_user_role` VALUES (30, 26, 5, 1, '2020-07-17 16:58:47');
INSERT INTO `tb_user_role` VALUES (32, 27, 7, 1, '2020-07-20 11:06:35');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
